Page 1

LILAC Document Help

Reports > Inventory > Markups Adjust

The purpose of this report is to edit (change) the Mark Up(s) in the Stock Account.

The following pages provide an example of adjusting the Mark Up on Standard Cost.
The Mark Up % calculates the Selling Price.

In the following example Mark Up 1 Retail, is adjusted for the four Product Codes in the Group ACCESSORIES from 50% to 55%.

After running the report, the User is able to select which Mark Up to adjust. If all 6 Mark Ups are to be adjusted the process is repeated for each Mark Up 1 to 6.

The OK button progresses to a review stage, after which a second OK will commit the changes to the Stock Account, potentially across thousands of Product Codes within the Stock Account.

Before the final commit, the Cancel button can be used to abort.

Example - Beginning

Page 2
Reports > Inventory > Markups Adjust

There are options to select a range of Product Codes to Adjust the Mark Up. In this example a Group : ACCESSORIES is selected, this Group contains four Product Codes. These Product Codes can be reviewed before committing to the adjustments.

Reports > Stock > Inventory > Markups
Reports > Stock > Extended Detail -> Convert to Excel
... are two other reports to review and perhaps temporarily save Product Code cost and price data for checking or reference.

First Window - Review

Clicking OK will progress without committing the proposed changes

Example Continiued

Page 3
Reports > Inventory > Markups Adjust

Second Window - Commit

Review the proposed changes.

The User may use the Cancel button at this stage. There will be no impact on the Stock Account.

Clicking OK -> WILL commit the proposed changes.

Process Complete

Example Complete

Page 4
Reports > Inventory > Markups Adjust

In the example Mark Up 1 has been adjusted from 50% to 55%.
The Selling Price in the Stock Account has automatically adjusted too, as a 55% Mark Up is in place

Another report, Reports > Inventory > Markups can be used to review.

Before

After